﻿/*
{
"状态":1,
"名称":"banner-图片轮播",
"作者":"马学兵",
"创建时间":"2018-09-11",
"功能":"banner-图片轮播",
"log": [
	{"date":"06-01" , "dev" :"hzhh" , "content" : ""}
]
}
*/


declare @deviceid varchar(50)
set @deviceid='{deviceid}'

;
WITH CT
AS
(
	SELECT TOP 5 * FROM k_banner WHERE deviceid='111'
ORDER BY update_time
)
UPDATE CT SET CT.update_time=GETDATE()
OUTPUT Inserted.*